Purpose
Keep track of status of krypto portfolio over time, based on transactions combined with current price data.
- Import krypto transaction data from spreadsheet.
- Download latest price data.
- Combine to calculate theoretical profit/loss trends.
- by currency
- overall portfolio
Method
- Log into crypto account.
- Download activity report.
- Go to spreadsheet in Marengo - check most recent transaction date there.
- Copy/paste new transactions from activity report.
- Copy down formulas in spreadsheet.
Bitcoin
|
date
|
acb
|
BTC-CAD.Close
|
diff
|
|
2021-12-04
|
$47,796.29
|
$63,011.70
|
31.83%
|
Transactions & Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
- Get latest price data.
- Combine with cost data.
- Calculate profit and ROI.
Ethereum
|
date
|
acb
|
ETH-CAD.Close
|
diff
|
|
2021-12-04
|
$1,649.60
|
$5,232.35
|
217.19%
|
Transactions & Adjusted Cost Base (Avg Cost)
Cardano
|
date
|
acb
|
ADA-CAD.Close
|
diff
|
|
2021-12-04
|
$2.64
|
$1.84
|
-30.39%
|
Transactions & Adjusted Cost Base (Avg Cost)
Polkadot
|
date
|
acb
|
DOT1-CAD.Close
|
diff
|
|
2021-12-04
|
$36.22
|
$37.84
|
4.49%
|
Transactions & Adjusted Cost Base (Avg Cost)
Litecoin
|
date
|
acb
|
LTC-CAD.Close
|
diff
|
|
2021-12-04
|
$228.96
|
$210.95
|
-7.87%
|
Transactions & Adjusted Cost Base (Avg Cost)
TOTALS
|
date
|
currency
|
book_val
|
market_val
|
profit
|
roi
|
|
2021-12-04
|
BTC
|
$3,177
|
$4,188
|
1,011
|
32%
|
|
2021-12-04
|
ETH
|
$5,954
|
$18,887
|
12,933
|
217%
|
|
2021-12-04
|
ADA
|
$5,801
|
$4,038
|
(1,763)
|
-30%
|
|
2021-12-04
|
DOT
|
$2,535
|
$2,649
|
114
|
4%
|
|
2021-12-04
|
LTC
|
$2,305
|
$2,124
|
(181)
|
-8%
|
|
date
|
total_invested
|
total_market_val
|
total_profit
|
total_roi
|
|
2021-12-04
|
$19,772
|
$31,886
|
$12,114
|
61%
|